﻿create table [dbo].[SM_User] (
   userid               uniqueidentifier         not null,
   operator_id          varchar(10)              not null,
   operator_name        varchar(20)              not null,
   depart_id            varchar(12)              not null,
   employee_id          varchar(20)              null,
   operator_type        varchar(2)               not null,  --00 administrator --01
   registe_date         datetime                 not null,
   cancel_date          datetime                 not null,
   status               char(1)                  not null,  --0 normal 1 invalid
   passwd               varchar(200)             not null,
   valid_date           datetime                 not null,
   chgpwd_date          datetime                 null,
   reg_userid           uniqueidentifier         null,
   cancel_userid        uniqueidentifier         null,
   pwdfail_times        int                      not null default 0,
   constraint PK_SM_USER primary key  (operator_id)
)